2015-08-06 - 18794.100 - Spec - Standard Inventory - Storage Location #InventoryManagement
SPECIFICATIONS
18794.100 - Standard Inventory - Storage Location
Purpose
Need to add grid value to Inventory source.
Admin Info
| Purpose |
Need to add grid value to Inventory source |
| Requested By |
Mark Harris |
| Spec Created By |
Naveen G |
| Spec Created Date |
08/12/2015 |
| Spec QA by |
Uday Kumar P |
| Objects |
0IC_C03, 2LIS_03_BX |
| Document Status |
Complete |
Estimates
| SNo |
Activity |
Estimation in Hours |
| 1 |
Research |
08 |
| 2 |
Documentation |
08 |
| 3 |
Development/ Config |
40 |
| 4 |
Unit test in DEV |
40 |
| 5 |
Unit test in QUA |
40 |
| 6 |
Other activity |
00 |
| TOTAL |
136 |
References
Prior Tickets
18794.200Documents
NoneSpec Changes
| SNo |
Change Details |
Requested By |
Requested On |
Notes if any |
Functional Requirement
Purpose/WHY:
Email from Greg Jackson on 08/25/2015:I have noticed that the 2LIS_03_BX (Stock Initialization for Inventory Management) extractor doesn't load material stock by size. Can you take a look into this and see if we can get it to populate size? The transactional data after the initialization isn't very clean once size is pulled onto the report. Size shows all negative/positive values based purely on the movements, not the actual stock. Below picture is a sale of 15EA:
In Scope:
Need to add Custom logic in CMOD to populate Grid for PO source.Out of Scope:
Other Inventory sources.Solution Summary
1. Need to identify the logic to update Grid value in 2LIS_03_BX datasource.
2. Need to implement the logic in CMOD for 2LIS_03_BX extractor.
3. Need to initialize the inventory extractors.
4. Need to load data into BW infocube to check if logic is getting populated correcty.
5. Need to validate the data in BPD & BPQ.
Test Plan
| SNo |
Test Scenario |
Expected Results |
| 1 |
Check if Grid value is populated correctly as per the logic. |
Grid value should be populated correctly as per the logic. |
| 2 |
Check if stock values are aligned in a line without negative values. |
Stock values should be aligned correctly without negative values. |
Solution Details
1. Identified the logic to update Grid value in 2LIS_03_BX datasource.
2. Implemented the logic in CMOD for 2LIS_03_BX extractor.
3. Initialized the inventory extractors 2LIS_03_BX, 2LIS_03_BF & 2LIS_03_UM.
4. Loaded data into BW infocube 0IC_C03 to check if logic is getting populated correctly using the BEx Queries.
5. Validated the data in BPD & BPQ.
6. Collected all the objects into transport request.
Issues
None